package com.example.mark.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.mark.entity.ComprehensiveMark;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

import java.math.BigInteger;

@Mapper
public interface ComprehensiveMarkMapper extends BaseMapper<ComprehensiveMark> {
    @Update("update comprehensive_mark SET "+
            "enviromental_rating = #{enviromentalRating}, food_rating = #{foodRating}, school_professional_rating = #{schoolProfessionalRating}, facility_rating = #{facilityRating}, comprehensive_score = #{comprehensiveScore}, count = #{count},update_time = #{updateTime} "+
            "WHERE college_id =#{collegeId}")
    int updateComprehensiveMarkByCollegeId(ComprehensiveMark comprehensiveMark);
}
